UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GvW0sWmi0cevX+bSQ8pRE+zh46HdokwiwsAhPbo+9M8='
WHERE
key_id = '02c6246767864ac6238995a9f64ce123fd8d365711d606982ed232865228308d'
AND (
token = 'GvW0sWmi0cevX+bSQ8pRE+zh46HdokwiwsAhPbo+9M8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)