UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pkwZH0WRzU07zPaeFzbKwIODImyq7VhjSKyZUzkmruI='
WHERE
key_id = '5ad788a20175df4c7c467686ff97c0e399a13eb58504f5fd88a7ea8707679a97'
AND (
token = 'pkwZH0WRzU07zPaeFzbKwIODImyq7VhjSKyZUzkmruI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)