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