UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k0gpg0ZXV0gDcoCUXGeMgkpcFtDg/C+oJIK8iPmHWZM='
WHERE
key_id = '1d3fc20c54749fba9af6b26ef10729326d1eb3a0bd40c507afd031bac49a17cc'
AND (
token = 'k0gpg0ZXV0gDcoCUXGeMgkpcFtDg/C+oJIK8iPmHWZM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)