UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4DIE1x1b5ZDUx3+M7B9SifVc2NRqdv94wQZb57Hdo3E='
WHERE
key_id = 'c682f1ece7dc8ccc08f4f8cf2ae5a193eab178a225af558b3d6b5796b3b627c3'
AND (
token = '4DIE1x1b5ZDUx3+M7B9SifVc2NRqdv94wQZb57Hdo3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)