UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b65AXy1KnqHY5mdokugOFF+EvogT0zoXV3pLShNCS2Y='
WHERE
key_id = 'effb535ffc4b18931dba47f8eb734a44c2258b087255235497ff2bf346a649f4'
AND (
token = 'b65AXy1KnqHY5mdokugOFF+EvogT0zoXV3pLShNCS2Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)