UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XDTngwMBVoGqo5PIPY6dSLGDE1iNJQ4sz6ZEFcE6FkY='
WHERE
key_id = 'f42b325b9896db8bb89fd1ea4061c078d7926dca16605c49dbd466af9d23ad53'
AND (
token = 'XDTngwMBVoGqo5PIPY6dSLGDE1iNJQ4sz6ZEFcE6FkY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)