UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9LIUXveQL+f41AYdKugmUR4lMNW0WaNhdQ93Msi1KMw='
WHERE
key_id = '1c18a9b16986f6428b08524057bd7864fbdd023ea7fcc07c01625129d367fc46'
AND (
token = '9LIUXveQL+f41AYdKugmUR4lMNW0WaNhdQ93Msi1KMw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)