UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KEAdmXvOiB6uLaVySDNRq0Tkxrg0PKwwenS48EbucTc='
WHERE
key_id = '9586297882395d4a6e13f0100a38b51fd99f72bf128a92c31a1915d4d50cc7ed'
AND (
token = 'KEAdmXvOiB6uLaVySDNRq0Tkxrg0PKwwenS48EbucTc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)