UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qNq76gRq7yU5wPEMbuAiVSdmLszdJE4R0U54U+y9RhU='
WHERE
key_id = 'e85e68605233e8b46b08434043801f73ad43cb946794b9186a4eb243926a07bb'
AND (
token = 'qNq76gRq7yU5wPEMbuAiVSdmLszdJE4R0U54U+y9RhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)