UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NJTYsfrlkTYh7QYZbkmcIHZedVkWTEGpak4WSnh6dwE='
WHERE
key_id = '10fd0afdbca172d8e591ee2b25af7b75457d9e8de765dd42b380ed05a49fd8aa'
AND (
token = 'NJTYsfrlkTYh7QYZbkmcIHZedVkWTEGpak4WSnh6dwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)