UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7JyRVW8OrOGtZ7gbq8ZGgFtnzHkFbLcTSq5wodbty1k='
WHERE
key_id = '7654570df66a81a4bc42a70f5a99ab1fab83d009eb8c3f036eb255ae53268900'
AND (
token = '7JyRVW8OrOGtZ7gbq8ZGgFtnzHkFbLcTSq5wodbty1k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)