UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HKBbrOI4thxNNhbNwANDd/ve7q/0jWsBcYcslt/ItcA='
WHERE
key_id = 'f0d97738424ee54499def9650bc3a7354a0a7597e2522b8e3c0052c18fdc40c7'
AND (
token = 'HKBbrOI4thxNNhbNwANDd/ve7q/0jWsBcYcslt/ItcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)