UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zTq6YM8TaDWf0PT6tuZWKg7PfFflZKjUYf9JJ7mOjpI='
WHERE
key_id = 'e7f5909542d626f1a4b9402a19686031ca8e0d3283575de2ac6b4b3449f322f2'
AND (
token = 'zTq6YM8TaDWf0PT6tuZWKg7PfFflZKjUYf9JJ7mOjpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)