UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tx+VBy7Hn73AI1vNA0M8HLkVSU2HeXo2lJO8Li5dHs4='
WHERE
key_id = 'fe562bda36fbe89e8c8e5e2ca1dfbf7507ce860c38e6737697459c21477a1ad9'
AND (
token = 'Tx+VBy7Hn73AI1vNA0M8HLkVSU2HeXo2lJO8Li5dHs4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)