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