UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q9kyN75brcmT9H4iLGEXji2C31/aO302uRs4hAFFm5w='
WHERE
key_id = '545d467097d3ab070173b40bb8b178c2daba94aa7195f1ab908943d3cbb78fd4'
AND (
token = 'q9kyN75brcmT9H4iLGEXji2C31/aO302uRs4hAFFm5w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)