UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CQxk3m/Q25XyKVmwS6O9Bica7XnEGzk7grH2Nu8MORw='
WHERE
key_id = 'e9a4899ed088df3625019885fc5411c5225566cc60650f2e9b11926a3e90e7a2'
AND (
token = 'CQxk3m/Q25XyKVmwS6O9Bica7XnEGzk7grH2Nu8MORw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)