UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G4F04EXJDi/9A5Cos1V73H2bPSlEy3civuOB2cghgDo='
WHERE
key_id = 'f476262a734799284967ea2928f4fb47cdb4e38b9fbe7df27229dc52fd29d4bb'
AND (
token = 'G4F04EXJDi/9A5Cos1V73H2bPSlEy3civuOB2cghgDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)