UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'AWRw2y7owvxcTmJt37lhrtvAhyb3oklUm7P226+JXEg=' 
WHERE 
  key_id = 'f6eb30a72e74cf0675b81cb2bbe7d0c8edc71b5dcc4e9b9fffd29687afcc6a67' 
  AND (
    token = 'AWRw2y7owvxcTmJt37lhrtvAhyb3oklUm7P226+JXEg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035