UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mfCc+1dWGmOkl3AKiJBcuoR0GwC+OjcDZYWiMbQudx8='
WHERE
key_id = 'ed97a11aaad883809049c826f1ce8325d6c27fb3753ab879852578e94a80beb7'
AND (
token = 'mfCc+1dWGmOkl3AKiJBcuoR0GwC+OjcDZYWiMbQudx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)