UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EfT+MTVdIue2gmrqB0+07DWc8AtlwB6PC2T2wVk6W9w='
WHERE
key_id = 'a06bb9960df81836c5f47984ee7377a174439f4a4c21413f802c08dc4635ad3c'
AND (
token = 'EfT+MTVdIue2gmrqB0+07DWc8AtlwB6PC2T2wVk6W9w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)