UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'imUScPXt1Her8aGyuV4EVAzrU6QUbJzKwYx4peBxIEU='
WHERE
key_id = 'b3bc95565802c2010ba1ea1aef1c7b0ff762cfcc2f1d1ed0eca3cc268ead3cd7'
AND (
token = 'imUScPXt1Her8aGyuV4EVAzrU6QUbJzKwYx4peBxIEU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)