UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3hMxG2zO0/ihMZQjQ4wPv6RO52uhIBf5INA7jwp/hK4='
WHERE
key_id = 'b2d8724eca3227c89bc38ac652a935176eba43a8b5340ab831da7d8cb73111b6'
AND (
token = '3hMxG2zO0/ihMZQjQ4wPv6RO52uhIBf5INA7jwp/hK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)