UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DPsKTJJZFQE8HDKp7VVS6DUq9k7YrUIc7v+Gmz3V5sE='
WHERE
key_id = '49e3ebf1f0e70fa1b486e20bdf1eb0e5ea0ae3f0ae2e1114f23871a17db00a49'
AND (
token = 'DPsKTJJZFQE8HDKp7VVS6DUq9k7YrUIc7v+Gmz3V5sE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)