UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9qlFoH+4woNMJeFrro1So7jSiL8xpCiFgy/2IjL5rQ='
WHERE
key_id = 'bece6c15ae98f4c6d091bcb9320f186839c2399e7db2a5dcd588878326256771'
AND (
token = 'r9qlFoH+4woNMJeFrro1So7jSiL8xpCiFgy/2IjL5rQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)