UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L47tYjjQ4/tpIy5Kw+jnGB81e1BPSmQKK0ktcMXASM8='
WHERE
key_id = '471a3039406eba5a527e1391206d4549466aa080edf06e038e0dae41c4b539f4'
AND (
token = 'L47tYjjQ4/tpIy5Kw+jnGB81e1BPSmQKK0ktcMXASM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)