UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fA1kl1HEpl+2AsnVlHptehACsNI4JLsH+qkKeg2qHUw='
WHERE
key_id = '8f76a541567b5d7e0af82400bb6730e0fd3c38ca58f5817b169790dae8f02225'
AND (
token = 'fA1kl1HEpl+2AsnVlHptehACsNI4JLsH+qkKeg2qHUw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)