UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z42qEmKfraBU0xvHac0sybhg9elD2bJITr4LbuLuP3k='
WHERE
key_id = 'd2c6a66853bdee5e12a350e1fd90f207feee2e8df9ab6f92401dcf8782512671'
AND (
token = 'Z42qEmKfraBU0xvHac0sybhg9elD2bJITr4LbuLuP3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)