UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7/9etvvM661AnnycV1OFK66ypPcGx7MItI0fMUN5Zzo='
WHERE
key_id = 'b2d931d0b4d1708ca0f789498a8d9a9e6a8ba5412252eb2f1a7b3fefbec34560'
AND (
token = '7/9etvvM661AnnycV1OFK66ypPcGx7MItI0fMUN5Zzo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)