UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BuqYWVwkUW73tjoZ7fF/eKZUXBLc2N/NPomSPBCx8GI='
WHERE
key_id = 'a80524fb62f771d4f193b7538c436ce587157e861a5b5889972d0ab95a70d076'
AND (
token = 'BuqYWVwkUW73tjoZ7fF/eKZUXBLc2N/NPomSPBCx8GI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)