UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uiveFXtYFC71dT3AYhOKn7lAHaACdPiPVd9GBg45I4w='
WHERE
key_id = 'ac8044e5e22309141f2de0c9c6bfb9028fb04b3ff583f6b4ee762930dc221891'
AND (
token = 'uiveFXtYFC71dT3AYhOKn7lAHaACdPiPVd9GBg45I4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)