UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9hdNvtOkcbW81lS3XtwBpu0EneBZEFUmTVNZbk9NhPA='
WHERE
key_id = 'ae5acc91ef2e48555debafa9867f136d03e4af71a607909bf3ec029022a34a89'
AND (
token = '9hdNvtOkcbW81lS3XtwBpu0EneBZEFUmTVNZbk9NhPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)