UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r2TvZW5WjmqjempH+p5hSF5Opn6QWWRUtOBjFrnT0Ug='
WHERE
key_id = 'dd4424ad798e3738fb0a0b8461fe030dca82968d5dfed27c9ddf4f2c65c9db7d'
AND (
token = 'r2TvZW5WjmqjempH+p5hSF5Opn6QWWRUtOBjFrnT0Ug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)