UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CVs07vJ59irftMRety5w0RX0lgccTrelowPLxr7vLOA='
WHERE
key_id = '628062735bae57e4e681fb4376e4da1721129a028fe729aca347a307436b7aa6'
AND (
token = 'CVs07vJ59irftMRety5w0RX0lgccTrelowPLxr7vLOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)