UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MS1qFwvF1O7fH+VpN8aKmO9RcX0sJ5zaF6sSUIXzfgQ='
WHERE
key_id = '1d1f27db9198286a957ba8f391d78e16d6529f49573bce2ec7e3943977b81205'
AND (
token = 'MS1qFwvF1O7fH+VpN8aKmO9RcX0sJ5zaF6sSUIXzfgQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)