UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7AHHuGD5BJKMjzGCozUm+6aWjDG3nl2XPH2B172YAa8='
WHERE
key_id = '53e9f46fdef19ed47ee36f5ce11fd47bf443fd3b07800b9744b1bff6681a1b5e'
AND (
token = '7AHHuGD5BJKMjzGCozUm+6aWjDG3nl2XPH2B172YAa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)